366,"ET_DE",0,0,"COLUMN CONSTRAINT","","DBMS-specific domain constraints for a column of a table."
364,"ET_DE",0,0,"ENTITY PHYSICAL PROPERTY","","The physical properties of an entity such as tablename."
361,"ET_DE",0,0,"REL PHYSICAL PROPERTY","","Represents DBMS dependent\nproperties of a relationship."
359,"ET_IE",0,0,"TARGET DBMS","",""
358,"ET_DE",0,0,"ERWIN DEFAULT","","A (global) default value for an attribute or attributes.\nThis needs to be attached to an attribute."
357,"ET_DE",0,0,"ERWIN DOMAIN","","A (global) domain for an attribute or attributes\nspecifying the legal values for an attribute.\nThis needs to be attached to an attribute."
350,"ET_DE",0,0,"INDEX MEMBER PHYSICAL PV","","The DBMS-specific\nphysical properties\nof the columns of an\nindex."
186,"ET_DE",0,0,"ERWIN DIAGRAM VIEW OBJECT","In ERwin/ERX 1.1 there are\nonly 2 views. The standard\nview 0, and the user view 1.\nBoth views have the same\ncoordinates. In later releases\nthere will be multiple views\neach with their own coordinate\nspaces.","An ERWIN DIAGRAM VIEW OBJECT\nis an ERwin object with graphical\ncoordinates located in a view.\nThis entity is designed to allow multiple\nviews of your diagram, each with\ndifferent graphical coordinates."
39,"ET_IE",0,0,"[ERWIN OBJECT]","This is a logical entity only. We include the OBJECT TYPE attribute so that IDs may overlap across \nobject types. This \nentity will not appear in same \nform in Server version. Instead \nthere will be separate dictionary \nand model object entities.\n\n","An ERWIN OBJECT is diagram-independent\nand shared by users and diagrams.\nIt is the object description\nthat identifies an ERwin object.\nThe same object can appear in\nthe same diagram in different views.\nAnd it can occur in different diagrams.\n[not a stored entity]"
40,"ET_DE",0,0,"[ERWIN DIAGRAM OBJECT]","Not stored in ERX 1.1\nIn Server version will\nplay important role.","Any object identified\nin a diagram.\n[not a stored entity]"
42,"ET_DE",0,0,"ERWIN ENTITY","In Server version\nthe definitional properties\nof an entity will be\nstored in the dictionary.","An ERWIN ENTITY is any\nobject about which you need\nto store information. The\nobject must be identifiable\nby a key. "
43,"ET_DE",0,0,"[ERWIN ATTRIBUTE]","Logical entity only in ERX 1.1.\nIn Server version these\nwill be stored in dictionary.","A \"logical\" entity, attributes are \nproperties of entities. They do not\nneed to be actually used in an entity.\nWhen used in an entity, they \ncorrespond to the columns\nof a physical table description. \n[not a stored entity]"
45,"ET_DE",0,0,"USER-DEFINED DATATYPE","User-defined datatypes are\nindependent of any diagram\nin ERX 1.1.","An ERwin USER-DEFINED DATATYPE\nis a user domain name. Support\nfor USER-DEFINED DATATYPES\ndepends on the DBMS."
47,"ET_DE",0,0,"ATTRIBUTE PHYSICAL PROPERTY","","The DBMS-specific physical\nproperties of an attribute."
49,"ET_IE",0,0,"[ERWIN DIAGRAM]","Logical entity only.\nServer version will maintain\nmultiple diagrams together\nwith a dictionary. ","A list of current ERwin diagrams.\nIn ERX 1.1, there is only one diagram.\n[not a stored entity]"
50,"ET_DE",0,0,"ERWIN ENTITY-ATTRIBUTE USAGE","The relationship id is used as part of the key of EAU rather than column position because in certain \ncases it is useful to know by which path two unified attributes have migrated. \nAlthough it is not stored in ERX, logically, there is a fish hook relationship on EAU showing how one \nattribute is related to its foreign keys via relationships. This important relationship is easy to derive as \na view of EAU. It is implicated in updating attribute names and other situations and has trigger rules. \nWe do not store it in ERX for reasons of simplicity. \n","The usage of an ERWIN \nATTRIBUTE in an ENTITY \n(EAU). Although we do not \nshow the subtype in this ERX \nstorage model, all attributes \nare owned or foreign. Owned \nattribute names are unique \nwithin an entity (but need not \nbe across the diagram). The \nsame foreign key attribute \n(basename) may occur more \nthan once in the same entity if \nit has different rolenames. \nAttributes are identified by \nFOREIGN KEY (i.e., \nrelationship id) and BASE \nNAME in addition to \nATTRIBUTE ID and \nENTITY ID.\n"
51,"ET_DE",0,0,"ERWIN RELATIONSHIP","ERWIN RELATIONSHIP\nstores SUBTYPE RELATIONSHIPs\nby storing the two graphical connections\nbetween a subcategory\nsymbol and its supertype and\nsubtype entities.\n","An ERWIN RELATIONSHIP \nrelates parent and child \nentities and may be a migration path \nfor foreign keys."
52,"ET_DE",0,0,"TEXT BLOCK","","Any block of text attached\nto an ERwin diagram view."
54,"ET_DE",0,0,"ERWIN SUBTYPE RELATIONSHIP","Logically, the SUBTYPE \nRELATIONSHIP is a single \nrelationship. However, in the \nERX storage model, subtypes \nare stored using two pseudo- \nrelationships in the ERWIN \nRELATIONSHIP entity. We \nare treating a SUBTYPE \nRELATIONSHIP as though it was \nan entity involved in two \nrelationships: \n(1) child in relation to supertype \n(2) parent in relation to subtype \nBut of course SUBTYPE \nRELATIONSHIPS are not really \nentities at all. It is really the \nsubtype graphical symbol that is \nbeing viewed as an \"entity\" from \nthe graphical point of view and \nthe \"relationships\" a SUBTYPE \nRELATIONSHIP enters into are \nreally only graphical. However, \nthey conveniently serve to \ncapture the single logical \nrelationship between supertype \nand subtype. \n\nIn ERX 1.1 for simplicity,\nwe did not record\nthe fact that a discriminator\nis always an attribute of the\nparent entity.\n","This ERX entity also called a \nSUBCATEGORY represents\nthe logical relationship between \nthe child \"sub-categorized\" entity\n(subtype) and the parent\n\"generalization\" (supertype)."
55,"ET_DE",0,0,"ERWIN DIAGRAM OPTION","","Lists the state of all ERwin options\nand option values for a saved\ndiagram."
60,"ET_DE",0,0,"ENTITY INDEX","All ERwin indexes\nare first defined as AKs\nor IEs at the logical\nlevel.","Primary, alternate and\ninversion entry indexes."
61,"ET_DE",0,0,"INDEX MEMBER","","The columns of an index."
63,"ET_DE",0,0,"ENTITY PHYSICAL PV","","The DBMS-specific\nphysical parameters and\nvalues associated with\nthe table used to store\ndata for an entity."
348,"ET_DE",0,0,"ENTITY TRIGGER","","The trigger code\n associated with a specific entity."
349,"ET_DE",0,0,"ENTITY TRIGGER UPDCOLS","","The update columns of an entity trigger."
368,"ET_DE",0,0,"ERWIN DOMAIN ELEMENT","","The enumeration of a domain."
/*
CREATE TABLE ERWIN_RELATIONSHIP
(RELATIONSHIP_ID INTEGER NOT NULL,
RELATIONSHIP_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
PARENT_ENTITY INTEGER NOT NULL,
PARENT_TYPE CHAR(6) NOT NULL,
CHILD_ENTITY INTEGER NOT NULL,
CHILD_TYPE CHAR(6) NOT NULL,
VERB_PHRASE CHAR(65),
CARDINALITY CHAR(6),
PARENT_DELETE_RULE CHAR(6),
PARENT_UPDATE_RULE CHAR(6),
CHILD_INSERT_RULE CHAR(6),
CHILD_DELETE_RULE CHAR(6),
CHILD_UPDATE_RULE CHAR(6),
PARENT_INSERT_RULE CHAR(6),
NULL_RULE CHAR(6),
RELATIONSHIP_DEF VARCHAR(255)
);
*/
89,"RT_ID",0,0,369,"ET_DE",373,"ET_DE","may be used as","CT_ZM","DR_CA","UR_CA","IR_RE","RI_NO","UR_CCA","RI_NO","NR_NN",""
1,88,"RT_ID","RELATIONSHIP ID",373,"ET_DE",0,0,0,"AT_PK","","","The id of a relationship. Value is -1 if no relationship.",-1
2,88,"RT_ID","RELATIONSHIP TYPE",373,"ET_DE",0,0,1,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
1,89,"RT_ID","TRIGGER TEMPLATE ID",373,"ET_DE",0,0,2,"AT_PK","","","The id of an object.\nIt overlaps across type.",-1
2,89,"RT_ID","TRIGGER TEMPLATE TYPE",373,"ET_DE",0,0,3,"AT_PK","","","The type of an object. Domain includes \nRelationship types: RT_ID, RT_NI, RT_SC, RT_MM\nAttribute Types: AT_PK, AT_NK\nEntity Types: ET_IE, ET_DE\nSubType Relationship Types: ST_IS, ST_CS\nText block Types: TB_TT",-1
38,88,"RT_ID","ERWIN DIAGRAM ID",373,"ET_DE",0,0,4,"AT_PK","","","The id of a diagram.",-1
38,89,"RT_ID","ERWIN DIAGRAM ID",373,"ET_DE",0,0,4,"AT_PK","","","The id of a diagram.",-1
135,89,"RT_ID","RESERVED",373,"ET_DE",0,0,5,"AT_PK","","","Reserved for use by Logic Works.",-1
135,88,"RT_ID","RESERVED",373,"ET_DE",0,0,5,"AT_PK","","","Reserved for use by Logic Works.",-1
1,74,"RT_ID","ENTITY ID",367,"ET_DE",0,0,2,"AT_PK","","","The id of an entity.",-1
2,74,"RT_ID","ENTITY TYPE",367,"ET_DE",0,0,3,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,74,"RT_ID","ERWIN DIAGRAM ID",367,"ET_DE",0,0,4,"AT_PK","","","The id of a diagram.",-1
135,74,"RT_ID","RESERVED",367,"ET_DE",0,0,5,"AT_PK","","","Reserved for use by Logic Works.",-1
1,72,"RT_ID","ATTRIBUTE ID",366,"ET_DE",0,0,2,"AT_PK","","","The id of an attribute. The same attribute is used in many entities as a foreign key.",-1
1,72,"RT_ID","FOREIGN KEY",366,"ET_DE",0,0,3,"AT_PK","","","If attribute in use is a foreign key,\nthe id of the relationship on which the\nforeign key migrates. Value is -1 if \nattribute is owned.",-1
2,72,"RT_ID","ATT REL TYPE",366,"ET_DE",0,0,4,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
54,72,"RT_ID","ENTITY-ATTRIBUTE BASE NAME",366,"ET_DE",0,0,5,"AT_PK","","","The name of an attribute as used in an entity (other than its rolename).",-1
1,72,"RT_ID","ENTITY ID",366,"ET_DE",0,0,6,"AT_PK","","","The id of an entity.",-1
2,72,"RT_ID","ENTITY TYPE",366,"ET_DE",0,0,7,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,72,"RT_ID","ERWIN DIAGRAM ID",366,"ET_DE",0,0,8,"AT_PK","","","The id of a diagram.",-1
135,72,"RT_ID","RESERVED",366,"ET_DE",0,0,9,"AT_PK","","","Reserved for use by Logic Works.",-1
1,67,"RT_ID","ENTITY ID",364,"ET_DE",0,0,0,"AT_PK","","","The id of an entity.",-1
2,67,"RT_ID","ENTITY TYPE",364,"ET_DE",0,0,1,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,67,"RT_ID","ERWIN DIAGRAM ID",364,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,67,"RT_ID","RESERVED",364,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
224,-1,"RT_OA","ENTITY SAMPLE DATA",364,"ET_DE",0,0,5,"AT_NK","","","Text for sample data.",-1
223,-1,"RT_OA","ENTITY QUERY",364,"ET_DE",0,0,6,"AT_NK","","","Text for queries.",-1
222,-1,"RT_OA","TABLENAME",364,"ET_DE",0,0,7,"AT_NK","","","The DBMS-specific name of the table.",-1
1,63,"RT_ID","RELATIONSHIP ID",361,"ET_DE",0,0,0,"AT_PK","","","The id of a relationship. Value is -1 if no relationship.",-1
2,63,"RT_ID","RELATIONSHIP TYPE",361,"ET_DE",0,0,1,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
38,63,"RT_ID","ERWIN DIAGRAM ID",361,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,63,"RT_ID","RESERVED",361,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
188,-1,"RT_OA","DOMAIN NAME",357,"ET_DE",0,0,2,"AT_NK","","","The name of the domain.",-1
189,-1,"RT_OA","DOMAIN RULE",357,"ET_DE",0,0,3,"AT_NK","","","The DBMS-specific\nexpression specifying \nlegal values for the domain.",-1
92,46,"RT_ID","INDEX ID",350,"ET_DE",0,0,0,"AT_PK","","","The id of an index in an entity. Index ids overlap across entities but are unique within an entity.",-1
97,46,"RT_ID","INDEX TYPE",350,"ET_DE",0,0,1,"AT_PK","","","Indexes are either primary key, alternate key\nor inversion entries. Primary and alternate key\nindexes are unique. Inversion entries are not\nunique.\n\nIndex Type\nIT_AK: Alternate Key\nIT_PK: Primary Key\nIT_IE: Inversion Entry",-1
1,46,"RT_ID","ATTRIBUTE ID",350,"ET_DE",0,0,2,"AT_PK","","","The id of an object. The same attribute is used in many entities as a foreign key.\n",-1
1,46,"RT_ID","FOREIGN KEY",350,"ET_DE",0,0,3,"AT_PK","","","If attribute in use is a foreign key, the id of the relationship on which the foreign key migrates. Value is -1 if attribute is owned.",-1
2,46,"RT_ID","ATT REL TYPE",350,"ET_DE",0,0,4,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
54,46,"RT_ID","ENTITY-ATTRIBUTE BASE NAME",350,"ET_DE",0,0,5,"AT_PK","","","The name of an attribute as used in an entity (other than its rolename).",-1
1,46,"RT_ID","ENTITY ID",350,"ET_DE",0,0,6,"AT_PK","","","The id of an entity.",-1
2,46,"RT_ID","ENTITY TYPE",350,"ET_DE",0,0,7,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,46,"RT_ID","ERWIN DIAGRAM ID",350,"ET_DE",0,0,8,"AT_PK","","","The id of a diagram.",-1
135,46,"RT_ID","RESERVED",350,"ET_DE",0,0,9,"AT_PK","","","Reserved for use by Logic Works.",-1
195,-1,"RT_OA","INDEX MEMBER PV NAME",350,"ET_DE",0,0,11,"AT_PK","","","The name of the index member physical property.",-1
196,-1,"RT_OA","INDEX MEMBER PV VALUE",350,"ET_DE",0,0,12,"AT_NK","","","The value of the index member physical property.",-1
92,43,"RT_ID","INDEX ID",347,"ET_DE",0,0,0,"AT_PK","","","The id of an index in an entity. Index ids overlap across entities but are unique within an entity.",-1
97,43,"RT_ID","INDEX TYPE",347,"ET_DE",0,0,1,"AT_PK","","","Indexes are either primary key, alternate key\nor inversion entries. Primary and alternate key\nindexes are unique. Inversion entries are not\nunique.\n\nIndex Type\nIT_AK: Alternate Key\nIT_PK: Primary Key\nIT_IE: Inversion Entry",-1
1,43,"RT_ID","ENTITY ID",347,"ET_DE",0,0,2,"AT_PK","","","The id of an entity.",-1
2,43,"RT_ID","ENTITY TYPE",347,"ET_DE",0,0,3,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,43,"RT_ID","ERWIN DIAGRAM ID",347,"ET_DE",0,0,4,"AT_PK","","","The id of a diagram.",-1
135,43,"RT_ID","RESERVED",347,"ET_DE",0,0,5,"AT_PK","","","Reserved for use by Logic Works.",-1
193,-1,"RT_OA","INDEX PV NAME",347,"ET_DE",0,0,7,"AT_PK","","","The name of the index physical property.",-1
194,-1,"RT_OA","INDEX PV VALUE",347,"ET_DE",0,0,8,"AT_NK","","","The value of the index physical property.",-1
1,42,"RT_ID","OBJECT ID",186,"ET_DE",0,0,0,"AT_PK",""," ","The id of an object.\nIt overlaps across type.",-1
2,42,"RT_ID","OBJECT TYPE",186,"ET_DE",0,0,1,"AT_PK",""," ","The type of an object. Domain includes \nRelationship types: RT_ID, RT_NI, RT_SC, RT_MM\nAttribute Types: AT_PK, AT_NK\nEntity Types: ET_IE, ET_DE\nSubType Relationship Types: ST_IS, ST_CS\nText block Types: TB_TT",-1
38,42,"RT_ID","ERWIN DIAGRAM ID",186,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,42,"RT_ID","RESERVED",186,"ET_DE",0,0,3,"AT_PK","VIEW ID","","The id of a view.\nERwin/ERX 1.1 there are\nonly 2 views. The standard\nview 0, and the user view 1.\nBoth views have the same\ncoordinates.",-1
127,-1,"RT_OA","XCOORD1",186,"ET_DE",0,0,4,"AT_NK",""," ","Graphical X coordinate #1",-1
126,-1,"RT_OA","YCOORD1",186,"ET_DE",0,0,5,"AT_NK",""," ","Graphical Y coordinate #1",-1
125,-1,"RT_OA","XCOORD2",186,"ET_DE",0,0,6,"AT_NK",""," ","Graphical X coordinate #2",-1
124,-1,"RT_OA","YCOORD2",186,"ET_DE",0,0,7,"AT_NK",""," ","Graphical Y coordinate #2",-1
1,-1,"RT_OA","OBJECT ID",39,"ET_IE",0,0,0,"AT_PK","","","The id of an object.\nIt overlaps across type.",-1
2,-1,"RT_OA","OBJECT TYPE",39,"ET_IE",0,0,1,"AT_PK","","","The type of an object. Domain includes \nRelationship types: RT_ID, RT_NI, RT_SC, RT_MM\nAttribute Types: AT_PK, AT_NK\nEntity Types: ET_IE, ET_DE\nSubType Relationship Types: ST_IS, ST_CS\nText block Types: TB_TT",-1
3,-1,"RT_OA","OBJECT DESCRIPTION",39,"ET_IE",0,0,2,"AT_NK","","","Diagram independent description of an object.",-1
1,1,"RT_ID","OBJECT ID",40,"ET_DE",0,0,0,"AT_PK","","","The id of an object.\nIt overlaps across type.",-1
2,1,"RT_ID","OBJECT TYPE",40,"ET_DE",0,0,1,"AT_PK","","","The type of an object. Domain includes \nRelationship types: RT_ID, RT_NI, RT_SC, RT_MM\nAttribute Types: AT_PK, AT_NK\nEntity Types: ET_IE, ET_DE\nSubType Relationship Types: ST_IS, ST_CS\nText block Types: TB_TT",-1
38,41,"RT_ID","ERWIN DIAGRAM ID",40,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,-1,"RT_OA","RESERVED",40,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
1,8,"RT_SC","OBJECT ID",42,"ET_DE",0,0,0,"AT_PK","ENTITY ID","","The id of an entity.",-1
2,8,"RT_SC","OBJECT TYPE",42,"ET_DE",0,0,1,"AT_PK","ENTITY TYPE","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,8,"RT_SC","ERWIN DIAGRAM ID",42,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,8,"RT_SC","RESERVED",42,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
47,-1,"RT_OA","ENTITY NAME",42,"ET_DE",0,0,4,"AT_NK","","","Name of an entity. Should be unique across model, though ERwin allows duplicate names depending on the Unique Name option.",-1
48,-1,"RT_OA","ENTITY NOTE",42,"ET_DE",0,0,5,"AT_NK","","","Text for entity note.",-1
49,-1,"RT_OA","ENTITY DEFINITION",42,"ET_DE",0,0,6,"AT_NK","","","Text for entity definition.",-1
1,9,"RT_SC","OBJECT ID",43,"ET_DE",0,0,0,"AT_PK","ATTRIBUTE ID","Value must be greater than 0.","The id of an attribute. The same attribute is used in many entities as a foreign key.",-1
2,9,"RT_SC","OBJECT TYPE",43,"ET_DE",0,0,1,"AT_PK","ATTRIBUTE TYPE","","Attributes are either keys or non-keys.\n\nAttribute Type\nAT_PK: Primary Key\nAT_NK: Non Key",-1
38,9,"RT_SC","ERWIN DIAGRAM ID",43,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,9,"RT_SC","RESERVED",43,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
69,-1,"RT_OA","USER-DEFINED DATATYPE NAME",45,"ET_DE",0,0,0,"AT_PK","","","The user supplied name for a user-defined datatype.",-1
137,-1,"RT_OA","USER-DEFINED PHYSICAL DATATYPE",45,"ET_DE",0,0,2,"AT_NK","","","Text for the physical datatype of the user-defined datatype",-1
138,-1,"RT_OA","USER-DEFINED NULL OPTION",45,"ET_DE",0,0,3,"AT_NK","","","Null option for the user defined datatype. \nOnly supported for SQL Server and Sybase.",-1
1,21,"RT_ID","ATTRIBUTE ID",47,"ET_DE",0,0,0,"AT_PK","","Value must be greater than 0.","The id of an attribute. The same attribute is used in many entities as a foreign key.",-1
1,21,"RT_ID","FOREIGN KEY",47,"ET_DE",0,0,1,"AT_PK","","","If attribute in use is a foreign key, the id of the relationship on which the foreign key migrates. Value is -1 if attribute is owned.",-1
2,21,"RT_ID","ATT REL TYPE",47,"ET_DE",0,0,2,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
54,21,"RT_ID","ENTITY-ATTRIBUTE BASE NAME",47,"ET_DE",0,0,3,"AT_PK","","","The name of an attribute as used in an entity (other than its rolename).",-1
1,21,"RT_ID","ENTITY ID",47,"ET_DE",0,0,4,"AT_PK","","","The id of an entity.",-1
2,21,"RT_ID","ENTITY TYPE",47,"ET_DE",0,0,5,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,21,"RT_ID","ERWIN DIAGRAM ID",47,"ET_DE",0,0,6,"AT_PK","","","The id of a diagram.",-1
135,21,"RT_ID","RESERVED",47,"ET_DE",0,0,7,"AT_PK","","","Reserved for use by Logic Works.",-1
84,-1,"RT_OA","COLUMN NAME",47,"ET_DE",0,0,9,"AT_NK","","","The physical field name of a column, usually shorter than the entity-attribute base name.",-1
85,-1,"RT_OA","NULL OPTION",47,"ET_DE",0,0,10,"AT_NK","","","DBMS-dependent null constraint on a column, e.g., NOT NULL.",-1
38,-1,"RT_OA","ERWIN DIAGRAM ID",49,"ET_IE",0,0,0,"AT_PK","","","The id of a diagram.",-1
39,-1,"RT_OA","ERWIN DIAGRAM NAME",49,"ET_IE",0,0,1,"AT_NK","","","Name of diagram.",-1
40,-1,"RT_OA","ERWIN VERSION NUMBER",49,"ET_IE",0,0,2,"AT_NK","","","Version of ERwin used to create diagram.",-1
41,-1,"RT_OA","DIAGRAM DATE",49,"ET_IE",0,0,3,"AT_NK","","","Date diagram last updated.",-1
42,-1,"RT_OA","ENTITY COUNT",49,"ET_IE",0,0,4,"AT_NK","","","Number of entities in a diagram.",-1
43,-1,"RT_OA","DIAGRAM AUTHOR",49,"ET_IE",0,0,5,"AT_NK","","","Author of a diagram.",-1
1,13,"RT_NI","ATTRIBUTE ID",50,"ET_DE",0,0,0,"AT_PK","","Value must be greater than 0.","The id of an attribute. The same attribute is used in many entities as a foreign key.",-1
1,23,"RT_NI","RELATIONSHIP ID",50,"ET_DE",0,0,1,"AT_PK","FOREIGN KEY","","If attribute in use is a foreign key,\nthe id of the relationship on which the\nforeign key migrates. Value is -1 if \nattribute is owned.",-1
2,23,"RT_NI","RELATIONSHIP TYPE",50,"ET_DE",0,0,2,"AT_PK","ATT REL TYPE","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
54,-1,"RT_OA","ENTITY-ATTRIBUTE BASE NAME",50,"ET_DE",0,0,3,"AT_PK","","","The name of an attribute as used in an entity (other than its rolename).",-1
1,12,"RT_ID","ENTITY ID",50,"ET_DE",0,0,4,"AT_PK","","","The id of an entity.",-1
2,12,"RT_ID","ENTITY TYPE",50,"ET_DE",0,0,5,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,12,"RT_ID","ERWIN DIAGRAM ID",50,"ET_DE",0,0,6,"AT_PK","","","The id of a diagram.",-1
135,12,"RT_ID","RESERVED",50,"ET_DE",0,0,7,"AT_PK","","","Reserved for use by Logic Works.",-1
38,13,"RT_NI","ERWIN DIAGRAM ID",50,"ET_DE",0,0,6,"AT_NK","","","The id of a diagram.",-1
38,23,"RT_NI","ERWIN DIAGRAM ID",50,"ET_DE",0,0,6,"AT_NK","","","The id of a diagram.",-1
135,13,"RT_NI","RESERVED",50,"ET_DE",0,0,7,"AT_NK","","","Reserved for use by Logic Works.",-1
135,23,"RT_NI","RESERVED",50,"ET_DE",0,0,7,"AT_NK","","","Reserved for use by Logic Works.",-1
98,-1,"RT_OA","COLUMN POSITION",50,"ET_DE",0,0,8,"AT_NK","","","Ordered position of an attribute as used in an entity.\nThough column position is determined at the logical\n level by the position of the attribute in the\nattribute list of the entity,\n it is more important for the physical schema level.",-1
2,13,"RT_NI","ATTRIBUTE TYPE",50,"ET_DE",0,0,9,"AT_NK","PRIMARY KEY","","Attributes are either keys or non-keys.\n\nAttribute Type\nAT_PK: Primary Key\nAT_NK: Non Key",-1
55,-1,"RT_OA","ENTITY-ATTRIBUTE ROLENAME",50,"ET_DE",0,0,10,"AT_NK","","In ERX 1.1, the definitional properties of an attribute\nalong the foreign key chain,\nmay differ for different foreign keys.\nIn the Server, to override the normal\ninherited properties, attributes will\nhave to be rolenamed.","Rolename of an attribute used primarily to indicate\nhow an attribute may play a different role as a foreign\nkey. If it exists, the rolename migrates not the basename.\nRolenames are used to unify attributes that occur \nmultiple times in an entity due to different migration\npaths. Rolenames are essential in certain configurations\nsuch as bill-of-materials.",-1
56,-1,"RT_OA","ENTITY-ATTRIBUTE NOTE",50,"ET_DE",0,0,11,"AT_NK","","","Note attached to an attribute.",-1
57,-1,"RT_OA","ENTITY-ATTRIBUTE DEFINITION",50,"ET_DE",0,0,12,"AT_NK","","","Definition text of an attribute.",-1
136,-1,"RT_OA","ENTITY-ATTRIBUTE PHYSICAL ORDER",50,"ET_DE",0,0,13,"AT_NK","","In ERX 1.1, ENTITY-ATTRIBUTE PHYSICAL ORDER\nis only introduced by reverse-engineering\na table with out of order primary keys.\nLater releases will provide an editor\nto change physical order independent \nof logical order.","The column position of a physical column\nin a table as distinct from the logical order.\nPrimary keys always precede non-keys\nat the logical level. This is not necessary\nat the physical level.",-1
1,22,"RT_SC","OBJECT ID",51,"ET_DE",0,0,0,"AT_PK","RELATIONSHIP ID","","The id of a relationship. Value is -1 if no relationship.",-1
2,22,"RT_SC","OBJECT TYPE",51,"ET_DE",0,0,1,"AT_PK","RELATIONSHIP TYPE","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
38,22,"RT_SC","ERWIN DIAGRAM ID",51,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,22,"RT_SC","RESERVED",51,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
38,11,"RT_NI","ERWIN DIAGRAM ID",51,"ET_DE",0,0,2,"AT_NK","","","The id of a diagram.",-1
38,34,"RT_NI","ERWIN DIAGRAM ID",51,"ET_DE",0,0,2,"AT_NK","","","The id of a diagram.",-1
38,35,"RT_NI","ERWIN DIAGRAM ID",51,"ET_DE",0,0,2,"AT_NK","","","The id of a diagram.",-1
38,10,"RT_NI","ERWIN DIAGRAM ID",51,"ET_DE",0,0,2,"AT_NK","","","The id of a diagram.",-1
135,11,"RT_NI","RESERVED",51,"ET_DE",0,0,3,"AT_NK","","","Reserved for use by Logic Works.",-1
135,34,"RT_NI","RESERVED",51,"ET_DE",0,0,3,"AT_NK","","","Reserved for use by Logic Works.",-1
135,10,"RT_NI","RESERVED",51,"ET_DE",0,0,3,"AT_NK","","","Reserved for use by Logic Works.",-1
135,35,"RT_NI","RESERVED",51,"ET_DE",0,0,3,"AT_NK","","","Reserved for use by Logic Works.",-1
1,10,"RT_NI","ENTITY ID",51,"ET_DE",0,0,4,"AT_NK","PARENT ENTITY","","The id of the parent entity in the relationship.",-1
1,34,"RT_NI","SUBTYPE ID",51,"ET_DE",0,0,4,"AT_NK","PARENT ENTITY","","The id of the parent entity.",-1
2,34,"RT_NI","SUBTYPE TYPE",51,"ET_DE",0,0,5,"AT_NK","PARENT TYPE","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity",-1
2,10,"RT_NI","ENTITY TYPE",51,"ET_DE",0,0,5,"AT_NK","PARENT TYPE","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
1,11,"RT_NI","ENTITY ID",51,"ET_DE",0,0,6,"AT_NK","CHILD ENTITY","","The id of the child entity in the relationship.",-1
1,35,"RT_NI","SUBTYPE ID",51,"ET_DE",0,0,6,"AT_NK","CHILD ENTITY","","The id of the child entity in the relationship.",-1
2,11,"RT_NI","ENTITY TYPE",51,"ET_DE",0,0,7,"AT_NK","CHILD TYPE","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
2,35,"RT_NI","SUBTYPE TYPE",51,"ET_DE",0,0,7,"AT_NK","CHILD TYPE","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity",-1
59,-1,"RT_OA","VERB PHRASE",51,"ET_DE",0,0,8,"AT_NK","","","The descriptive verb phrase labelling a relationship.",-1
61,-1,"RT_OA","CARDINALITY",51,"ET_DE",0,0,9,"AT_NK","",""," Cardinality Types are: zero, one, or more;\nzero or one; at least one (positive); and exactly n.\n\nCardinality Type\nCT_ZM: Zero,one,or More\nCT_ZR: Zero or one Relationship\nCT_PR: Positive (one or more) relationship\nN: exactly N\n",-1
237,-1,"RT_OA","PARENT DELETE RULE",51,"ET_DE",0,0,10,"AT_NK","","","Rule specifying Referential Integrity option \nwith respect to the child FK on deleting data from the parent.",-1
238,-1,"RT_OA","PARENT UPDATE RULE",51,"ET_DE",0,0,11,"AT_NK","","","Rule specifying Referential Integrity option \nwith respect to the child FK on updating PK of the parent.",-1
239,-1,"RT_OA","CHILD INSERT RULE",51,"ET_DE",0,0,12,"AT_NK","","","Rule specifying Referential Integrity option \nwith respect to the parent on inserting data into the child.",-1
240,-1,"RT_OA","CHILD DELETE RULE",51,"ET_DE",0,0,13,"AT_NK","","","Rule specifying Referential Integrity option \nwith respect to the parent on deleting a child instance.",-1
241,-1,"RT_OA","CHILD UPDATE RULE",51,"ET_DE",0,0,14,"AT_NK","","","Rule specifying Referential Integrity option \nwith respect to the parent on updating the foreign key\nof the child.",-1
64,-1,"RT_OA","NULL RULE",51,"ET_DE",0,0,16,"AT_NK","","","Null Rules specify whether a relationship allows NULLs\nor not. Identifying relationships\ndo not allow nulls. Only non-identifying relationships\nhave a null option. A non-identifying diamond relationship allows\nnulls, a non-identifying relationship with no\ndiamond (the symbol at the parent end) is a mandatory\nrelationship (no nulls).\n\nNull Rule\nNR_NA: Nulls Allowed (Diamond)\nNR_NN: No Nulls (Mandatory)",-1
140,-1,"RT_OA","RELATIONSHIP DEFINITION",51,"ET_DE",0,0,17,"AT_NK","","","Text for relationship definition.",-1
1,7,"RT_SC","OBJECT ID",52,"ET_DE",0,0,0,"AT_PK","TEXT BLOCK ID","","The id of a text block.",-1
2,7,"RT_SC","OBJECT TYPE",52,"ET_DE",0,0,1,"AT_PK","TEXT BLOCK TYPE","","Text block Type\nTT_TB: Text Block",-1
38,7,"RT_SC","ERWIN DIAGRAM ID",52,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,7,"RT_SC","RESERVED",52,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
46,-1,"RT_OA","TEXT BLOCK TEXT",52,"ET_DE",0,0,4,"AT_NK","","","The text string associated with a text block.",-1
1,26,"RT_SC","OBJECT ID",54,"ET_DE",0,0,0,"AT_PK","SUBTYPE ID","","The id of a subtype relationship.",-1
2,26,"RT_SC","OBJECT TYPE",54,"ET_DE",0,0,1,"AT_PK","SUBTYPE TYPE","","Subcategories, also known as subtype relationships\nare complete (mutually exclusive and exhaustive)\n or incomplete (need not be exhaustive).\n\nSubtype relationship Type\nST_CS: Complete Subtype\nST_IS: Incomplete Subtype\n",-1
38,26,"RT_SC","ERWIN DIAGRAM ID",54,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,26,"RT_SC","RESERVED",54,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
91,-1,"RT_OA","DISCRIMINATOR NAME",54,"ET_DE",0,0,4,"AT_NK","","","The name of a subtype relationship's discriminator.",-1
38,5,"RT_ID","ERWIN DIAGRAM ID",55,"ET_DE",0,0,0,"AT_PK","","","The id of a diagram.",-1
44,-1,"RT_OA","OPTION NAME",55,"ET_DE",0,0,1,"AT_PK","","","Diagram Option\nDO_RV: Relationship Verb phrase display\nDO_RC: Relationship Cardinality Display\nDO_NN: schema Not Null display\nDO_SD: Schema Display\nDO_ST: Schema dataType display\nDO_EE: Entity Editor\nDO_RE: Relationship Editor\nDO_PG: Page Grid\nDO_EW: Entity Width\nDO_EH: Entity Height\nDO_AR: Attribute/Rolenames display\nDO_AK: Alternate Key display\nDO_DL: Display Level\nDO_LG: Layout Grid\nDO_XL: X Layout grid\nDO_YL: Y Layout grid\nDO_FK: schema FK display\nDO_UN: Unique Names option\nDO_TD: Target Dbms\nDO_AI: Attribute definition Inheritance\nDO_DD: Default Datatype\nDO_FH: Font Height\nDO_FW: Font Width\nDO_FE: Font Escapement\nDO_FO: Font Orientation\nDO_FG: Font weiGht\nDO_FI: Font Italic\nDO_FU: Font Underline\nDO_FS: Font Strikeout\nDO_FC: Font Charset\nDO_OP: Out Precision\nDO_CP: Clip Precision\nDO_FQ: Font Quality\nDO_FP: Font Pitch and Family\nDO_FN: Font face Name\nDO_DN: Diagram Default Null Option for Non-keys\nDO_PF: Diagram Preferences\nDO_VW: Diagram View Option\n",-1
45,-1,"RT_OA","OPTION VALUE",55,"ET_DE",0,0,2,"AT_NK","","","The value of a diagram option.",-1
92,-1,"RT_OA","INDEX ID",60,"ET_DE",0,0,0,"AT_PK","","","The id of an index in an entity. Index ids overlap across entities but are unique within an entity.",-1
97,-1,"RT_OA","INDEX TYPE",60,"ET_DE",0,0,1,"AT_PK","","","Indexes are either primary key, alternate key\nor inversion entries. Primary and alternate key\nindexes are unique. Inversion entries are not\nunique.\n\nIndex Type\nIT_AK: Alternate Key\nIT_PK: Primary Key\nIT_IE: Inversion Entry",-1
1,36,"RT_ID","ENTITY ID",60,"ET_DE",0,0,2,"AT_PK","","","The id of an entity.",-1
2,36,"RT_ID","ENTITY TYPE",60,"ET_DE",0,0,3,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,36,"RT_ID","ERWIN DIAGRAM ID",60,"ET_DE",0,0,4,"AT_PK","","","The id of a diagram.",-1
135,36,"RT_ID","RESERVED",60,"ET_DE",0,0,5,"AT_PK","","","Reserved for use by Logic Works.",-1
93,-1,"RT_OA","INDEX NAME",60,"ET_DE",0,0,6,"AT_NK","","","The physical name of an index.",-1
92,38,"RT_ID","INDEX ID",61,"ET_DE",0,0,0,"AT_PK","","","The id of an index in an entity. Index ids overlap across entities but are unique within an entity.",-1
97,38,"RT_ID","INDEX TYPE",61,"ET_DE",0,0,1,"AT_PK","","","Indexes are either primary key, alternate key\nor inversion entries. Primary and alternate key\nindexes are unique. Inversion entries are not\nunique.\n\nIndex Type\nIT_AK: Alternate Key\nIT_PK: Primary Key\nIT_IE: Inversion Entry",-1
1,37,"RT_ID","ATTRIBUTE ID",61,"ET_DE",0,0,2,"AT_PK","","Value must be greater than 0.","The id of an attribute. The same attribute is used in many entities as a foreign key.",-1
1,37,"RT_ID","FOREIGN KEY",61,"ET_DE",0,0,3,"AT_PK","","","If attribute in use is a foreign key, the id of the relationship on which the foreign key migrates. Value is -1 if attribute is owned.",-1
2,37,"RT_ID","ATT REL TYPE",61,"ET_DE",0,0,4,"AT_PK","","","Relationships are identifying, non-identifying, subtypes (subcategories),\nmany-to-many. All foreign key attributes have a\nvalid relationship type. Owned attributes are given a\ndefault value for relationship type (which is really\nNULL).\n\nRelationship Type\nRT_ID: IDentifying relationship\nRT_NI: Non-Identifying relationship\nRT_SC: SubCategory or (subtype) relationship \nRT_MM: Many-to-Many relationship \nRT_OA: Owned Attribute (no relationship)\n",-1
54,37,"RT_ID","ENTITY-ATTRIBUTE BASE NAME",61,"ET_DE",0,0,5,"AT_PK","","","The name of an attribute as used in an entity (other than its rolename).",-1
1,37,"RT_ID","ENTITY ID",61,"ET_DE",0,0,6,"AT_PK","","","The id of an entity.",-1
1,38,"RT_ID","ENTITY ID",61,"ET_DE",0,0,6,"AT_PK","","","The id of an entity.",-1
2,38,"RT_ID","ENTITY TYPE",61,"ET_DE",0,0,7,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
2,37,"RT_ID","ENTITY TYPE",61,"ET_DE",0,0,7,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,38,"RT_ID","ERWIN DIAGRAM ID",61,"ET_DE",0,0,8,"AT_PK","","","The id of a diagram.",-1
38,37,"RT_ID","ERWIN DIAGRAM ID",61,"ET_DE",0,0,8,"AT_PK","","","The id of a diagram.",-1
135,38,"RT_ID","RESERVED",61,"ET_DE",0,0,9,"AT_PK","","","Reserved for use by Logic Works.",-1
135,37,"RT_ID","RESERVED",61,"ET_DE",0,0,9,"AT_PK","","","Reserved for use by Logic Works.",-1
94,-1,"RT_OA","INDEX POSITION",61,"ET_DE",0,0,10,"AT_NK","","","The position of a column in an index. This\nhas an important impact on performance\nand sort order.",-1
1,68,"RT_ID","ENTITY ID",63,"ET_DE",0,0,0,"AT_PK","","","The id of an entity.",-1
2,68,"RT_ID","ENTITY TYPE",63,"ET_DE",0,0,1,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,68,"RT_ID","ERWIN DIAGRAM ID",63,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,68,"RT_ID","RESERVED",63,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
109,-1,"RT_OA","PHYS PROP NAME",63,"ET_DE",0,0,4,"AT_PK","","When Target DBMS is NetWare: \nUSING DCOMPRESS \n PAGESIZE PREALLOCATE OWNER \nOWNERACCESS WITH REPLACE\n","The name of a an entity's\nphysical property.",-1
110,-1,"RT_OA","PHYS PROP VALUE",63,"ET_DE",0,0,6,"AT_NK","","","The values for the DBMS-specific property.",-1
1,70,"RT_ID","ENTITY ID",348,"ET_DE",0,0,0,"AT_PK","","","The id of an entity.",-1
2,70,"RT_ID","ENTITY TYPE",348,"ET_DE",0,0,1,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,70,"RT_ID","ERWIN DIAGRAM ID",348,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,70,"RT_ID","RESERVED",348,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
1,45,"RT_ID","ENTITY ID",349,"ET_DE",0,0,0,"AT_PK","","","The id of an entity.",-1
2,45,"RT_ID","ENTITY TYPE",349,"ET_DE",0,0,1,"AT_PK","","","Entities are either independent or dependent.\nET_IE: Independent Entity\nET_DE: Dependent Entity\n",-1
38,45,"RT_ID","ERWIN DIAGRAM ID",349,"ET_DE",0,0,2,"AT_PK","","","The id of a diagram.",-1
135,45,"RT_ID","RESERVED",349,"ET_DE",0,0,3,"AT_PK","","","Reserved for use by Logic Works.",-1
225,-1,"RT_OA","DOMAIN ELEMENT NAME",368,"ET_DE",0,0,"TD_SS","DOMAIN_ELEMENT_NAM","NOT NULL","","ERWIN NAME",-1
226,-1,"RT_OA","DOMAIN ELEMENT DESCRIPTION",368,"ET_DE",0,0,"TD_SS","DOMAIN_ELEMENT_DESC","NULL","","ERWIN TEXT",-1
/*
CREATE TABLE USER_DEFINED_DTYPE
(UDD_NAME CHAR(65) NOT NULL,
TARGET_DBMS CHAR(6) NOT NULL,
UDD_TYPE CHAR(65),
UDD_NULL INTEGER,
DEFAULT_ID INTEGER,
DOMAIN_ID INTEGER
);
*/
"ERWIN FK NAME","TD_SS","CHAR(8)",0,-1,-1
"ERWIN ID","TD_SS","INTEGER",0,0,-1
"ERWIN NAME","TD_SS","CHAR(65)",0,1,-1
"ERWIN TEXT","TD_SS","VARCHAR(255)",0,-1,-1
"ERWIN TYPE","TD_SS","CHAR(6)",0,2,-1
/*
CREATE TABLE DIAGRAM_OPTION
(ERWIN_DIAGRAM_ID INTEGER NOT NULL,
OPTION_NAME CHAR(6) NOT NULL,
OPTION_VALUE CHAR(65)
);
*/
0,"DO_RV",1
0,"DO_RC",1
0,"DO_NN",1
0,"DO_SD",0
0,"DO_ST",3
0,"DO_EE",36
0,"DO_RE",44
0,"DO_PG",1
0,"DO_EW",0
0,"DO_EH",0
0,"DO_AR",1
0,"DO_AK",1
0,"DO_DL",1
0,"DO_LG",0
0,"DO_XL",0
0,"DO_YL",0
0,"DO_FK",0
0,"DO_UN",0
0,"DO_TD",172
0,"DO_AI",7003
0,"DO_DD","CHAR(18)"
0,"DO_DG",0
0,"DO_FH",58
0,"DO_FW",0
0,"DO_FE",0
0,"DO_FO",0
0,"DO_FG",700
0,"DO_FI",0
0,"DO_FU",0
0,"DO_FS",0
0,"DO_FC",0
0,"DO_OP",0
0,"DO_CP",2
0,"DO_FQ",0
0,"DO_FP",34
0,"DO_FN","Arial"
0,"DO_DN",0
0,"DO_PF",1
0,"DO_VW",9
0,"DO_SR",1
0,"DO_PR",0
0,"DO_ICI","IR_RE"
0,"DO_IPD","DR_RE"
0,"DO_IPU","UR_RE"
0,"DO_IPI","RI_NO"
0,"DO_ICD","RI_NO"
0,"DO_ICU","UR_CRE"
0,"DO_ACI","IR_SN"
0,"DO_APD","DR_SN"
0,"DO_APU","UR_SN"
0,"DO_API","RI_NO"
0,"DO_ACD","RI_NO"
0,"DO_ACU","UR_CSN"
0,"DO_NCI","IR_RE"
0,"DO_NPD","DR_RE"
0,"DO_NPU","UR_RE"
0,"DO_NPI","RI_NO"
0,"DO_NCD","RI_NO"
0,"DO_NCU","UR_CRE"
0,"DO_SCI","IR_RE"
0,"DO_SPD","DR_CA"
0,"DO_SPU","UR_CA"
0,"DO_SPI","RI_NO"
0,"DO_SCD","RI_NO"
0,"DO_SCU","UR_CRE"
/*
CREATE TABLE TEXT_BLOCK
(TEXT_BLOCK_ID INTEGER NOT NULL,
TEXT_BLOCK_TYPE CHAR(6) NOT NULL,
ERWIN_DIAGRAM_ID INTEGER NOT NULL,
RESERVED INTEGER NOT NULL,
TEXT_BLOCK_TEXT VARCHAR(255)
);
*/
62,"TT_TB",0,0,"Logic Works ERwin/ERX 1.2a\nERX Storage Model\n4/20/93\n\nEntities not stored are marked by [].\n\nCopyright (c) Logic Works, 1991-93.\nAll rights reserved."
24,"TR_BI",0,0,"TD_SS","PARENT UPDATE SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON PARENT UPDATE SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
25,"TR_BI",0,0,"TD_SS","PARENT DELETE SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON PARENT DELETE SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
26,"TR_BI",0,0,"TD_SS","PARENT INSERT SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON PARENT INSERT SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
27,"TR_BI",0,0,"TD_SS","CHILD INSERT SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON CHILD INSERT SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
28,"TR_BI",0,0,"TD_SS","CHILD UPDATE SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON CHILD UPDATE SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
29,"TR_BI",0,0,"TD_SS","CHILD DELETE SET DEFAULT","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON CHILD DELETE SET DEFAULT */\n/* Application specific. Left out intentionally. */","RI_NO"
30,"TR_BI",0,0,"TD_SS","CHILD DELETE SET NULL","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON CHILD DELETE SET NULL */\n/* Application specific. Left out intentionally. */","RI_NO"
31,"TR_BI",0,0,"TD_SS","PARENT INSERT SET NULL","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON PARENT INSERT SET NULL */\n/* Application specific. Left out intentionally. */","RI_NO"
32,"TR_BI",0,0,"TD_SS","PARENT INSERT CASCADE","/* ERwin Builtin %Datetime */\n/* %Parent %VerbPhrase %Child ON PARENT INSERT CASCADE */\n/* Application specific. Left out intentionally. */","RI_NO"
